--2016/6/22   添加材料信息菜单及 T_BIZ_CLXX 表
---材料信息
insert into t_sys_cd (id,deleted,mc,url,fcd_id,lx,pxh) values (seq_sys_cd.nextval,0,'材料信息','base/clxx/clxx',92,'xtcd',13);


-- Create table
create table T_BIZ_CLXX
(
  id       NUMBER(19) not null,
  date_created  TIMESTAMP(6),
  deleted       NUMBER(10),
  last_updated  TIMESTAMP(6),
  jd       VARCHAR2(255 CHAR),
  ccrq     TIMESTAMP(6),
  ccch     VARCHAR2(255 CHAR),
  xshth    VARCHAR2(255 CHAR),
  cljz     FLOAT,
  clmz     FLOAT,
  cljs     NUMBER(10),
  ckmdh    VARCHAR2(255 CHAR),
  xsgsmc   VARCHAR2(255 CHAR),
  dyshyhmc VARCHAR2(255 CHAR),
  deshyhmc VARCHAR2(255 CHAR),
  dzmc     VARCHAR2(255 CHAR),
  jsyhmc   VARCHAR2(255 CHAR),
  zzyhmc   VARCHAR2(255 CHAR),
  gg       VARCHAR2(255 CHAR),
  ph       VARCHAR2(255 CHAR),
  pzmc     VARCHAR2(255 CHAR),
  ckzt     VARCHAR2(255 CHAR),
  cjsj     VARCHAR2(255 CHAR),
  clh      VARCHAR2(255 CHAR),
  zt       VARCHAR2(255 CHAR),
  bz       VARCHAR2(255 CHAR)
)
tablespace WLY
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 4M
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Add comments to the columns 
comment on column T_BIZ_CLXX.jd
  is '基地';
comment on column T_BIZ_CLXX.ccrq
  is '出厂日期';
comment on column T_BIZ_CLXX.ccch
  is '出厂车号';
comment on column T_BIZ_CLXX.xshth
  is '销售合同号';
comment on column T_BIZ_CLXX.cljz
  is '材料净重';
comment on column T_BIZ_CLXX.clmz
  is '材料毛重';
comment on column T_BIZ_CLXX.cljs
  is '材料件数';
comment on column T_BIZ_CLXX.ckmdh
  is '出库码单号';
comment on column T_BIZ_CLXX.xsgsmc
  is '销售公司名称';
comment on column T_BIZ_CLXX.dyshyhmc
  is '第一收货用户名称';
comment on column T_BIZ_CLXX.deshyhmc
  is '第二收货用户名称';
comment on column T_BIZ_CLXX.dzmc
  is '到站名称';
comment on column T_BIZ_CLXX.jsyhmc
  is '结算用户名称';
  comment on column T_BIZ_CLXX.zzyhmc
  is '最终用户名称';
  comment on column T_BIZ_CLXX.gg
  is '规格';
  comment on column T_BIZ_CLXX.ph
  is '牌号';
  comment on column T_BIZ_CLXX.pzmc
  is '品种名称';
  comment on column T_BIZ_CLXX.ckzt
  is '出库状态';
  comment on column T_BIZ_CLXX.cjsj
  is '创建时间';
  comment on column T_BIZ_CLXX.clh
  is '材料号';
  comment on column T_BIZ_CLXX.zt
  is '状态';
  comment on column T_BIZ_CLXX.bz
  is '备注';

-- Create/Recreate primary, unique and foreign key constraints 
alter table T_BIZ_CLXX
  add primary key (ID)
  using index 
  tablespace WLY
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 192K
    next 1M
    minextents 1
    maxextents unlimited
  );



-- Create sequence 
create sequence SEQ_BIZ_CLXX
minvalue 0
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 21;

alter table t_biz_jydd add stander_from VARCHAR2(255 CHAR);
          